PTD Billing

The PTD Billing report shows period to date (PTD) billed WIP. You can monitor billed WIP by category, subcategory, and service code, and adjust the level of detail to include.

Note: The PTD Billing report does not include progress billing.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>
• Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is PTD Billing. In Practice Advantage, the comparable report is Billing Review.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Hide Details	Yes/No	Includes or excludes details of each transaction. If hidden, select to subtotal your groups to view the amounts for each selected grouping.
Use Expense in Realization Percentage	Yes/No	Includes or excludes the expense transactions in the realization calculation.
Use Expense in Effective Rate	Yes/No	Includes or excludes the expense transactions in the effective rate calculation.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Pennies	Yes/No	Includes or excludes pennies in the amounts.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information

Default Filters
Field Name	Operator	Value
Invoice Date	Between	First Day of Current Fiscal Year, Today

Optional Filters
Available Fields
Accounting Period Date	Client Name	Invoice Amount
Business Code	Client Office	Invoice Date
Category	Client Primary Service Type	Invoice Number
Client	Client Region	Line of Business
Client – Principal	Client Sub ID	Manager
Client Bill Manager	Client Type	Posted Date
Client Billing Group	Effective Rate	Primary Partner
Client Business Unit	Expenses	Real%
Client ID	Financial Reporting Client Group	Return Group
Client ID.Sub ID	Hours	Service Code
Subcategory	Tax Type	Write Up/Down

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client Name	Manager
Category	Client Office	Primary Partner
Client	Client Primary Service Type	Return Group
Client – Principal	Client Region	Service Code
Client Bill Manager	Client Sub ID	Sort Name
Client Billing Group	Client Type	Subcategory
Client Business Unit	Financial Reporting Client Group	Tax Type
Client ID	Invoice Date
Client ID.Sub ID	Line of Business

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Category	Invoice Amount	Service Code
Effective Rate	Invoice Date	Subcategory
Expenses	Invoice Number	Write Up/Down
Hours	Real %

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Category	The category ID the service code is assigned to.
Subcategory	The subcategory ID the service code is assigned to.
Service Code	The transaction service code in Service Code Name (Service Code ID) format.
Invoice Date	The transaction invoice date.
Invoice Number	The number that is assigned to the invoice.
Invoice Amount	The amount of the invoice. The calculation is billed WIP +/- write up/down.
Write Up/Down	The total write up/down for the invoice.
Real %	The transaction realization percentage. The calculation is billed amount + write up/down divided by billed amounts, excluding expenses (unless you selected to include expenses).
Effective Rate	The effective rate for that transaction. The calculation is billed amount + write up/down divided by billed hours, excluding expenses (unless you selected to include expenses).
Expenses	The total expenses billed on the invoice without write up/down.
Hours	The total number of hours included on the invoice.

PTD Billing Sample Report